To Create Feature-Linked Text
-
Create the table with one geometry column, one ID, one angle field, and one foreign key.
CREATE TABLE LINKED_TEXT
(Id NUMBER PRIMARY KEY,
LinkedID NUMBER,
Angle NUMBER,
GEOMETRY MDSYS.SDO_GEOMETRY);
-
Insert the table metadata in the Oracle Spatial metadata.
INSERT INTO USER_SDO_GEOM_METADATA (TABLE_NAME, COLUMN_NAME, DIMINFO, SRID)
VALUES (‘LINKED_TEXT', 'GEOMETRY',
MDSYS.SDO_DIM_ARRAY
(MDSYS.SDO_DIM_ELEMENT('X', 714099.913898663, 715312.343907550, 0.000000050),
MDSYS.SDO_DIM_ELEMENT('Y', 4908438.586694972, 4910715.465519385, 0.000000050)),
82247);
COMMIT;
-
Create the spatial index of type point to use rotation.
CREATE INDEX linkedtext_idx ON linked_text(Geometry)
INDEXTYPE IS MDSYS.SPATIAL_INDEX PARAMETERS ('layer_gtype=point');
-
Create the foreign key constraint defining the feature-linked text.
alter table LINKED_TEXT
add constraint LINKEDTEXT_FK
foreign key(LINKEDID)
references LINE(ID)
ON DELETE CASCADE;